package com.medical.manage.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.medical.manage.domain.Department;
import com.medical.manage.domain.Pharmacology;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @Author：waikaipeng
 * @Package：com.medical.manage.mapper
 * @Project：medical
 * @name：PharmacologyMapper
 * @Date：2025年3月7日 00:02
 */
@Mapper
@Repository
public interface PharmacologyMapper extends BaseMapper<Pharmacology> {
    @Select(" \tSELECT t_pharmacology.*,t_medical.* FROM t_pharmacology LEFT JOIN t_medical ON t_pharmacology.pharmacology_id= t_medical.pharmacology_id limit 1")
    Pharmacology getPharmacologyId(int pharmacologyId);
}
